Quiz 14
Question # 1
Given the following Students table, which function has been used to assign ranks to rows based on the Marks column as shown:
Students
| Name | Marks | Row_Number |
|---|---|---|
| A | 89 | 2 |
| B | 65 | 5 |
| C | 74 | 4 |
| D | 91 | 1 |
| E | 89 | 3 |
A)
ROW_NUMBER()
B)
RANK()
C)
DENSE_RANK()
Question # 2
Given the following Students table, which function has been used to assign ranks to rows based on the Marks column as shown:
Students
| Name | Marks | Row_Number |
|---|---|---|
| A | 89 | 2 |
| B | 65 | 5 |
| C | 74 | 4 |
| D | 91 | 1 |
| E | 89 | 3 |
A)
ROW_NUMBER()
B)
RANK()
C)
DENSE_RANK()
Question # 3
Which of the following functions CANNOT be used in MySQL to validate the format of a date?
A)
DAYNAME()
B)
STR_TO_DATE()
C)
TIMESTAMPDIFF()
D)
ISDATE()
Question # 4
How can we rotate rows of a table into columns in MySQL? In other words how can we take transpose of a row?
A)
Use the PIVOT() function.
B)
Use the TRANSPOSE() function.
C)
Use CASE expression along with an aggregate function.
Question # 5
Which number can be stored without the loss of any digit if the data type is declared as DECIMAL(6,3)?
A)
60.0034
B)
600.034
C)
6000.34
